named_place¶Shape: (127420, 17)
| pk_named_place | concat_napl | concat_standard_name | begin_year | end_year | standard_latitude | standard_longitude | notes | creator | creation_time | modifier | modification_time | fk_abob_type_napl | notes_begin | certainty_begin | notes_end | certainty_end | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82419 | 61696.0 | NaPl61696 | Castron | NaN | NaN | 43.9066 | 0.866847 | NaN | 4.0 | 2009-11-05 17:50:27.000 | 4.0 | 2014-12-03 16:46:04 | 156.0 | NaN | NaN | NaN | NaN |
| 7467 | 23054.0 | NaPl23054 | Sainte-Marthe | NaN | NaN | NaN | NaN | Commune existante au 1er janvier 2009. Importe... | 4.0 | 2009-10-28 16:09:51.000 | 4.0 | 2014-12-03 17:04:13 | 697.0 | NaN | NaN | NaN | NaN |
| 17998 | 32979.0 | NaPl32979 | Poiseul | NaN | NaN | NaN | NaN | Commune existante au 1er janvier 2009. Importe... | 4.0 | 2009-10-28 16:13:22.000 | 4.0 | 2014-12-03 17:04:13 | 697.0 | NaN | NaN | NaN | NaN |
| 36882 | 44039.0 | NaPl44039 | Rouen | NaN | NaN | NaN | NaN | Commune existante au 1er janvier 2009. Importe... | 4.0 | 2009-10-28 16:14:05.000 | 4.0 | 2014-12-03 17:04:13 | 697.0 | NaN | NaN | NaN | NaN |
| 110972 | 84437.0 | NaPl84437 | Mlay | NaN | NaN | 47.7401 | 3.946170 | NaN | 4.0 | 2009-11-05 17:51:50.000 | 4.0 | 2014-12-03 16:46:04 | 156.0 | NaN | NaN | NaN | NaN |
Columns contain: Total number of rows: 127420 - "pk_named_place": 0.00% empty - 127420 (100.00%) uniques (eg: 15922.0; 15923.0) - "concat_napl": 0.00% empty - 127420 (100.00%) uniques (eg: NaPl15922; NaPl15923) - "concat_standard_name": 0.00% empty - 84480 ( 66.30%) uniques (eg: Vbre; Ventenac) - "fk_abob_type_napl": 0.00% empty - 6 ( 0.00%) uniques (eg: 697.0; 156.0) - "modification_time": 0.00% empty - 1499 ( 1.18%) uniques (eg: 2014-12-03...; 2014-12-03...) - "creation_time": 0.00% empty - 2541 ( 1.99%) uniques (eg: 2009-10-28...; 2010-03-03...) - "creator": 0.00% empty - 50 ( 0.04%) uniques (eg: 4.0; 26.0) - "modifier": 0.00% empty - 48 ( 0.04%) uniques (eg: 4.0; 26.0) - "standard_latitude": 32.64% empty - 68972 ( 54.13%) uniques (eg: nan; 46.983333) - "standard_longitude": 32.64% empty - 78600 ( 61.69%) uniques (eg: nan; 2.25) - "notes": 39.35% empty - 1198 ( 0.94%) uniques (eg: Commune ex...; nan) - "certainty_end": 95.75% empty - 4 ( 0.00%) uniques (eg: nan; 1.0) - "certainty_begin": 95.77% empty - 4 ( 0.00%) uniques (eg: nan; 1.0) - "begin_year": 95.85% empty - 279 ( 0.22%) uniques (eg: nan; 1700.0) - "notes_begin": 96.13% empty - 5 ( 0.00%) uniques (eg: nan; 4.0) - "end_year": 96.16% empty - 107 ( 0.08%) uniques (eg: nan; 1800.0) - "notes_end": 96.23% empty - 5 ( 0.00%) uniques (eg: nan; 3.0)
According to the table before, we will parse each column by the most meaningful type.
Here we will report analysis of interesting information found on different columns. They are not exhaustive.
We replace the not filled values by 0.
We replace the not filled values by 0.